|
SQL Processing Using File Input is a database facility invented by IBM for interfacing with their DB2 system. It is accessed from within TSO ISPF from the DB2I Primary Option menu. SPUFI allows direct input of SQL commands in the TSO environment, rather than having them embedded within a program. ==SPUFI defaults== Once set up the SPUFI defaults are unlikely to be changed. Their values are very similar across installations, a typical example is shown below. CURRENT SPUFI DEFAULTS SSID: DDBA ===> ____________________________________________________________________________ Enter the following to control your SPUFI session: 1 SQL TERMINATOR .. ===> ; (SQL Statement Terminator) 2 ISOLATION LEVEL ===> CS (RR=Repeatable Read, CS=Cursor Stability) 3 MAX SELECT LINES ===> 250 (Maximum number of lines to be returned from a SELECT) Output data set characteristics: 4 RECORD LENGTH ... ===> 4092 (LRECL=Logical record length) 5 BLOCK SIZE ...... ===> 4096 (Size of one block) 6 RECORD FORMAT ... ===> VB (RECFM=F, FB, FBA, V, VB, or VBA) 7 DEVICE TYPE ..... ===> SYSDA (Must be DASD unit name) Output format characteristics: 8 MAX NUMERIC FIELD ===> 33 (Maximum width for numeric fields) 9 MAX CHAR FIELD .. ===> 80 (Maximum width for character fields) 10 COLUMN HEADING .. ===> NAMES (NAMES, LABELS, ANY or BOTH) 抄文引用元・出典: フリー百科事典『 ウィキペディア（Wikipedia）』 ■ウィキペディアで「IBM Spufi」の詳細全文を読む スポンサード リンク
|